SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:100 NORTH THETFORD ROAD- Updated, impeccably maintained Cape sited on a stunning nearly 4-acre parcel with breathtaking long-range views. The open concept interiors feature vaulted ceilings and effortless flow, designed to welcome abundant natural light and showcase the landscaped grounds, vistas, and abutting conserved land. A well-appointed kitchen with beautiful woodwork and adjacent dining area together with a sizable deck and covered patio make it perfect for entertaining family and friends alike. The living room is both grand and cozy, with built in bookshelves flanking the east side and a propane stove for cooler months. Also on the main level are a large en suite primary bedroom with office area, a second bedroom with a full bathroom, and laundry room. Upstairs is a private loft space and third bedroom accessed from a magical custom wood landing. The walkout lower level offers an additional finished living area–perfect as an office or recreation room–as well as ample storage space. Attached to the house via the lovely breezeway/patio is a newer 3-bay garage barn with a private heated woodshop, and storage above that has potential for conversion to additional finished space. Two Solaflect solar trackers help with annual electricity production. With its comfortable and versatile interiors, stunning grounds and views, and perfect location to access points both north and south, this move-in-ready home has something for everyone.
Description:This substantial expanded Cape offers an exceptional blend of multi-generational living, extensive workspace, and expansive acreage. The main residence features five bedrooms and four and a half bathrooms, anchored by a beautiful Crown Point Cabinetry kitchen equipped with abundant cabinet and counter space, a woodstove, and direct access to a porch designed for summer dining. A large, elegant living room centers around a classic Rumford fireplace. Recent updates include a new oil-fired boiler with ten heating zones alongside a whole-house generator. A two-car garage provides convenient attached parking. Complementing the main house is a detached guest house featuring a character-rich post and beam upper frame with a sleeping loft and a full bathroom. For projects and storage, the property includes a 24x60 storage building and a premier 24x44 workshop outfitted with radiant floor heat, an 80-gallon compressor, and a 2,000-pound traveling hoist. Set on 107.5 acres, the grounds feature an in-ground saltwater swimming pool, an established pond, a seasonal brook, and an extensive network of trails and wood roads. Beautiful landscaping frames the home, complete with mature plantings of blueberries, rhubarb, and Christmas trees, creating a private and versatile rural retreat.
Description:Stunning views from almost every window of this 3 bedroom, 3.5 bathroom colonial. This house has it ALL! Renovated kitchen with bar seating and sunny breakfast nook, living room with big stone fireplace, primary suite with sitting room and western skies from your soaking tub, two other second floor bedrooms that share a full bathroom. Additionally, 2 first floor offices, formal dining room for entertaining, large family room and workout space in the walk out lower level, three car attached garage, and tons of storage! While outdoors, you will enjoy decks, a covered front porch, a lovely patio and pool. Set on 13.54 magical acres on one of Lebanon's most scenic roads, this is a perfect location - minutes to Dartmouth Health, downtown Lebanon and easy access to I89.
Description:Just a short stroll from the Lyme Common sits a charming one-of-a-kind gem! Once a blacksmith shop, now a truly unique thoughtfully reimagined home with wonderful gathering spaces enriched by hardwood and wide pine floors, quality built-ins and even a fabulous patio where you can enjoy a cup of coffee while taking in beautiful gardens and an expansive lawn. The property consists of a four-bedroom main house in addition to a 2019 built two-bedroom cottage presently being used as an office. Wander up Market Street to find restaurants, shops and award-winning Lyme Elementary School or get there via The Big Rock Nature Preserve trail directly across from your front door. Lyme offers many recreational opportunities from the Dartmouth Skiway, cross country skiing at the Greens to Post Pond for swimming and of course extensive hiking trails and a short drive to Dartmouth College, Hanover and DHMC. Open Houses Sat May 23 & Sun May 24 from 12-2pm.The listing agent holds an ownership interest in the property.
Description:This charming 1990s Gambrel-style home offers 95 feet of prime frontage on Crystal Lake, complete with deep water access and a private sandy beach—perfect for swimming, boating, and year-round lake living. Inside, warm wood finishes create a cozy, inviting atmosphere throughout the home. The first floor has a large gourmet kitchen featured in 'Signature Kitchens & Baths' magazine, walk out to the spacious deck and enjoy views of the lake. Head upstairs to a full bathroom and three spacious bedrooms, all filled with abundant natural light. The primary bedroom faces the lake and features inviting built-in window seats. The finished basement is ideal for entertaining, featuring a spacious layout and a large wet bar ready for hosting gatherings. A detached three-car garage includes an accessory dwelling unit (ADU) above, providing excellent space for guests, rental income, or a private home office. Whether you're looking for a peaceful retreat or an active waterfront lifestyle, this property captures the best of lake living. Open House Saturday 5/23/26 10AM-12PM